﻿using RTW.Core.Helper;
using RTW.Models;
using RTW.Servers;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace RTW.Web
{
    public class SeedData
    {
        public void Initialize()
        {


            string dbtype = AppSettingsManager.Get("DbContexts:DbType");

            switch (dbtype)
            {
                case "Sqlite":
                    sqlite();break;
            }

        }



        public void sqlite() {
            HomeMenuServer _menuServer = new HomeMenuServer();
            TMenuServer _tmenuServer = new TMenuServer();
            TDepartmentServer departmentServer = new TDepartmentServer();
            TUserInfoServer userInfoServer = new TUserInfoServer();
            TRoleServer roleServer = new TRoleServer();
            TOrganizationServer organizationServer = new TOrganizationServer();
            TBaseDataServer baseDataServer = new TBaseDataServer();

            if (departmentServer.Count() == 0)
            {
                string sql = "INSERT INTO \"TDepartment\" VALUES ('27137dffa6bb48bc9b7f97dc82964dd4', '', '湖北省人民检察院', 'XX000021', ',27137dffa6bb48bc9b7f97dc82964dd4,', 1, 1, '', 1, NULL, NULL, '/WaterMark/27137dffa6bb48bc9b7f97dc82964dd4.png', '[全宗号]-[年度]-[机构代码]-[期限代码]-(案卷号,4)', '[全宗号]-WS•[年度]-[期限代码]-[机构代码]-(件号,4)', '0');";
                _ = departmentServer.ExecSqlAsync(sql);
            }

            if (userInfoServer.Count() == 0)
            {
                //string sql = @" INSERT INTO TUserInfo VALUES ('b72a5aa0696f49c487118be508ea28c3', '管理员', 'admin', 'AA0D771FDC3F968E', '1a21caed48be431b93d6e0494f86a152', '2113885a1d63483da41080942686a84b', '', 0, 1, '', '', '', '87', '65', '83', '68', '70', '', '', '32', '71', '', '', '38', '40', '', '', '', '', '', '', '', '90', '', '', '32', '70', '81', '', '', '', '72', '65', '71', '', '', '', '', '83', '68', '', '82', '', '', '', '', '', '', 'zui-theme-black-light', '', '2016-01-20 10:19:58', 0, 100, 1, '\headImg\浪漫\OrangeHeart.png', '', '', '27137dffa6bb48bc9b7f97dc82964dd4', '1', 'admin', NULL, NULL);";
                //_ = userInfoServer.ExecSqlAsync(sql);

                var userinfo = new RTW.Models.TUserInfo();
                userinfo.ID = "b72a5aa0696f49c487118be508ea28c3";
                userinfo.UserName = "管理员";
                userinfo.UserAccount = "admin";
                userinfo.UserPwd = "D15AB379C7397D5B";
                userinfo.OrgID = "1a21caed48be431b93d6e0494f86a152";
                userinfo.RoleID = "2113885a1d63483da41080942686a84b";
                userinfo.IsUndergo = 0;
                userinfo.Theme = "zui-theme-black-light";
                userinfo.AddTime = Convert.ToDateTime("2016-01-20 10:19:58");
                userinfo.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                userinfo.Bak1 = @"\headImg\浪漫\OrangeHeart.png";
                userinfo.EditID = "0";
                userInfoServer.Insert(userinfo);
            }
            if (roleServer.Count() == 0)
            {
                //string sql = @" INSERT INTO TRole VALUES ('19f28ad4670048008ece2b899ba2880c', '干警', 0, '', '', '2017-04-05 09:25:09', 15, 1, 0, '', '', '', '27137dffa6bb48bc9b7f97dc82964dd4');
                //                INSERT INTO TRole VALUES('2113885a1d63483da41080942686a84b', '系统管理员', 0, '', '', '2016-02-17 14:55:35', 1, 3, 0, '', '', '', '27137dffa6bb48bc9b7f97dc82964dd4');
                //                INSERT INTO TRole VALUES('2cb2a63658894adab036e39893a4fe1e', '处室内勤', 0, '', '', '2016-05-09 10:09:43', 12, 1, 0, '', '', '', '27137dffa6bb48bc9b7f97dc82964dd4');
                //                INSERT INTO TRole VALUES('62d8fe4ae5ff49b581b5fc567a96f845', '院领导', 0, NULL, '', '2019-08-14 17:29:13.863', 2, 3, 0, NULL, NULL, NULL, '27137dffa6bb48bc9b7f97dc82964dd4');
                //                INSERT INTO TRole VALUES('80dbc285276145699bc0eb56fb47bd5c', '档案管理员', 0, '', '', '2016-06-21 09:29:51', 13, 3, 0, '', '', '', '27137dffa6bb48bc9b7f97dc82964dd4');
                //                INSERT INTO TRole VALUES('d4907605837d45e4b25d5b696940ff89', '档案扫描', 0, '', '', '2016-03-17 14:55:07', 11, 3, 0, '', '', '', '27137dffa6bb48bc9b7f97dc82964dd4');
                //                INSERT INTO TRole VALUES('dc29983d95664cc89eb6b8001a379e04', '处室领导', 0, '', '', '2017-04-05 09:11:36', 14, 2, 0, '', '', '', '27137dffa6bb48bc9b7f97dc82964dd4');";
                //                _ = roleServer.ExecSqlAsync(sql);

                TRole role = new TRole();
                role.ID = "19f28ad4670048008ece2b899ba2880c";
                role.RName = "干警";
                role.AddTime= Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);
                role.ID = "2113885a1d63483da41080942686a84b";
                role.RName = "系统管理员";
                role.AddTime = Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);
                role.ID = "2cb2a63658894adab036e39893a4fe1e";
                role.RName = "处室内勤";
                role.AddTime = Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);

                role.ID = "62d8fe4ae5ff49b581b5fc567a96f845";
                role.RName = "院领导";
                role.AddTime = Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);
                role.ID = "80dbc285276145699bc0eb56fb47bd5c";
                role.RName = "档案管理员";
                role.AddTime = Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);
                role.ID = "d4907605837d45e4b25d5b696940ff89";
                role.RName = "档案扫描";
                role.AddTime = Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);

                role.ID = "dc29983d95664cc89eb6b8001a379e04";
                role.RName = "处室领导";
                role.AddTime = Convert.ToDateTime("2020-09-09 18:17:29.057");
                role.State = 0;
                role.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                roleServer.Insert(role);
            }

            if (baseDataServer.Count() == 0)
            {
                //string sql = @"INSERT INTO TBaseData VALUES (N'00c4e657544b4320992f5fb48d4c5fae', N'侦查监督部', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-13 13:26:12.920' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'02634413497242aa9ff8bc170b6d338e', N'痕检', N'02', N'', 0, N'', N'技术类别', CAST(N'2016-05-24 15:58:40.030' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'02bf8e30003e4d3e913954bcf5ab8509', N'汉中街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 10:17:47.000' AS DateTime), 23, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'02cd467ac08947c0a992772b4e9b96c3', N'法制大队（长丰）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 10:39:17.000' AS DateTime), 26, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'04eaa5b18f0e4d95b0a87431e30a23de', N'案件评查', N'ajpc', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:04:20.617' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'05ecd5690e0140ca94c9de283e94ad1f', N'卷', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:26:07.123' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'08ecfa22b36844d0b1451f5d7bc015f0', N'易家街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-21 09:20:51.000' AS DateTime), 37, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'0bf7f152fa8648c3bcaca239a95426d3', N'光盘', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:22:33.000' AS DateTime), 11, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'0c795c0449a24305aa825fa5a69cf35f', N'奖牌', N'', N'', 0, N'', N'实物类型', CAST(N'2016-05-18 10:25:08.627' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'0cc2f7b37076443f9f5775da75f905da', N'发展派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-19 16:43:39.170' AS DateTime), 22, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'0dbc650fe3804464b2c251f12e2dfdb9', N'综合检察部（刑事执行检察）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-16 14:42:22.640' AS DateTime), 20, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'1070385688f241b9a3f5c07e0a40ae78', N'硚口区公安局法制大队（宝丰所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-08-28 14:29:24.363' AS DateTime), 62, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'11de44bedd7e427cb2e9051deccb6ad4', N'武汉市公安局江岸分局经侦大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-12-06 11:09:25.363' AS DateTime), 52, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'145323cd132b44ffabc9faa6bc8bed74', N'永久', N'Y', N'文书', 0, N'', N'保管期限', CAST(N'2016-02-02 10:43:53.000' AS DateTime), 21, NULL, NULL, N'永久', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'1742525fd2694ce5b7db6ef3aa3dd4d4', N'荣华街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-27 14:36:14.800' AS DateTime), 45, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'1949919cb55040c280e8b9940a6938dd', N'16开', N'', N'', 0, N'', N'规格', CAST(N'2016-05-18 10:27:14.663' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'1bac8e393cd9496e816d0299433f15c2', N'硚口区公安分局法制大队（古田）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-14 09:01:53.387' AS DateTime), 4, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'1bebb6903a6a49508100bdaae2d0b395', N'页', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:25:59.920' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'1dc2e7a0941e430ea1cfdc3b3465a921', N'法制大队（三曙）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-21 15:31:51.960' AS DateTime), 38, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'1e0ba9959059486da5a73970ffef86ba', N'硚口区公安分局法制大队（汉水所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 16:33:40.553' AS DateTime), 34, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'1f0774df9b744a1fb303462c1e0c990b', N'韩家墩街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-23 16:20:39.747' AS DateTime), 44, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'206c3f0e3fc34ca7bab043407c54d42a', N'长丰街发展派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-27 14:53:09.000' AS DateTime), 47, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'23ee07ae08c34b8ca6e74bf5cb9d2eed', N'60年', N'2', N'诉讼', 0, N'', N'保管期限', CAST(N'2019-09-20 09:58:10.390' AS DateTime), 5, NULL, NULL, N'长期', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'23f6c142269247a7aaebdaa80928a78e', N'办案参考', N'back', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:03:58.193' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'277d08ee77144a6abddfb67b96c8b858', N'其他', N'qt', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:05:51.083' AS DateTime), 8, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'2815102bb7874753b089eaf79cb9a2c1', N'奖杯', N'', N'', 0, N'', N'实物类型', CAST(N'2016-05-18 10:25:01.220' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'28fdddc511894a6faa03b5939cca162d', N'公诉部（未成年人附条件不起诉案件）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 14:14:29.277' AS DateTime), 79, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'292415f38b83479b9a0e4f5ebba54e08', N'未成年刑事检察科', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-15 11:00:40.027' AS DateTime), 11, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'2a3a9a5793f74d0aada002f67e034013', N'武汉市公安局交通管理局', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-14 14:24:34.910' AS DateTime), 9, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'2a4f19e62a3f494db9303ce4224da6cd', N'公诉部（未成年人刑事公诉案件）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-16 09:02:26.657' AS DateTime), 16, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'2ac6319e5ca748999bd4317f6c03aef5', N'汉正街三曙派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-22 16:34:18.063' AS DateTime), 39, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'2ac8c8cb2e8647ab961874c5c334697c', N'法制大队（汉水所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-27 14:04:57.377' AS DateTime), 70, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'31d6ee4f66e941fcbe10f11547cb041a', N'公诉部（未成年人刑事批捕案件）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-16 09:02:56.317' AS DateTime), 17, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'32191b78c5d049b4ab89f573b42a579b', N'10年', N'10N', N'文书', 0, N'', N'保管期限', CAST(N'2016-02-02 10:46:47.000' AS DateTime), 24, NULL, NULL, N'10年', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'333d8e3942be4a5d8a771910de1149af', N'宗关街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-23 16:08:17.257' AS DateTime), 43, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'34b94098dca2418f829f70669f39b44e', N'调研', N'dy', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:05:39.440' AS DateTime), 7, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'34f39d15b92c4d5aabd7137165f62364', N'侦查监督科', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-15 15:40:51.117' AS DateTime), 12, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'35accbf866ad4c8995b4576f07a4d486', N'其他', N'', N'', 0, N'', N'会计类别', CAST(N'2016-05-18 10:28:35.117' AS DateTime), 5, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'373ad8a5ccb249d0acffe501eb306b1c', N'4开', N'', N'', 0, N'', N'规格', CAST(N'2016-05-18 10:27:30.220' AS DateTime), 4, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'38e80a6d67b94ad7838bc68c95206b15', N'汉正街利济派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-23 11:13:49.000' AS DateTime), 42, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'3995d7c24b764a91a2605d9b2570c430', N'永久', N'1', N'诉讼', 0, N'', N'保管期限', CAST(N'2017-08-10 16:34:14.000' AS DateTime), 1, NULL, NULL, N'永久', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'3a8506cf1e9343aca23fe3e8e8d02de5', N'硚口区公安局法制大队（长丰）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 14:54:47.580' AS DateTime), 81, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'3f2bd39a16c4492693f6349b467ee2dd', N'缣帛', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:21:24.000' AS DateTime), 5, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'421f93db6a034a7f8958f9872635eefa', N'民事行政检察部', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-16 12:03:08.277' AS DateTime), 19, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'4263865f4f9744f5b44b2a62c0522752', N'汉兴街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-30 16:41:53.497' AS DateTime), 49, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'435967aa2c1c4fcda84757652785e531', N'法制大队（韩家所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 16:43:59.107' AS DateTime), 83, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'49b22d1bd0e540f7aa70ab38bf392ed5', N'长期', N'C', N'文书', 0, N'', N'保管期限', CAST(N'2016-02-02 10:45:54.000' AS DateTime), 22, NULL, NULL, N'长期', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'4a1e3235f76e4b2eb841a3ec619b0024', N'武汉市公安局硚口区交通大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-08-29 09:21:00.763' AS DateTime), 65, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'4c5dd572a55e4495ae8d3b0689266616', N'硚口区公安局法制大队（宗关所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 10:48:24.987' AS DateTime), 77, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'548a94a7c46344208c927809d0995629', N'硚口区公安分局法制大队（发展）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-15 17:24:49.183' AS DateTime), 14, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'56b99643b366459286b125d2701f774b', N'纸张', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:22:57.697' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'57d4d4c868f344178852eae78aee5eb7', N'桥口区公安分局长丰派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-10 08:57:50.633' AS DateTime), 67, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'5c24d7035e0e46a69b7239315a3a7e4c', N'公开', N'', N'#93CC29', 0, N'', N'密级', CAST(N'2016-05-18 10:33:39.000' AS DateTime), 4, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'5de9de1ac82e4232a71844249203552f', N'贪污贿赂犯罪侦查部', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-13 13:25:28.450' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'5e8911f9adfe4ae7babbe409e8d98e1d', N'民行部', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-08-05 10:13:01.740' AS DateTime), 60, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'620bc54cf6d64c3cbe089dda54319e7f', N'电子证据检验', N'06', N'', 0, N'', N'技术类别', CAST(N'2016-05-24 15:59:51.520' AS DateTime), 5, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'6265e4c66e4e429a88f905834d8c8e5f', N'国内', N'', N'#6B69D6', 0, N'', N'密级', CAST(N'2016-05-18 10:33:55.000' AS DateTime), 6, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'65c83cb036314613a2b4c4127812785b', N'古田街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-21 09:04:10.640' AS DateTime), 36, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'663cc420628b4fe2b8f1feb6653a7f6d', N'会计报表', N'', N'', 0, N'', N'会计类别', CAST(N'2016-05-18 10:28:16.130' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'69119b4fa75c462eae8c7baddbf758bf', N'反贪污贿赂局', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-23 10:08:32.000' AS DateTime), 41, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'6a2ca6a41db949568edb93321258b155', N'未检科', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 16:48:39.893' AS DateTime), 35, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'6b22d220e03b49f5bd52b41136905fb5', N'渎职侵权犯罪侦查部', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-14 12:04:17.967' AS DateTime), 8, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'6d5ac756958849e2b946aff26c696384', N'30年', N'3', N'诉讼', 0, N'', N'保管期限', CAST(N'2019-09-20 09:57:50.860' AS DateTime), 4, NULL, NULL, N'短期', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'6e16dc4bafbf43f0916f7ba42e970a82', N'武汉市公安局硚口区分局经侦大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-27 14:45:22.440' AS DateTime), 46, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'705987d83d7c47628a934929027336fe', N'张', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:26:29.297' AS DateTime), 5, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'70840b03904d4b6dae1aa9786fa504c6', N'磁盘', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:22:24.000' AS DateTime), 10, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'71c4172900eb4783807e4dd782266288', N'综合检察部（控申科）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-16 11:29:18.570' AS DateTime), 18, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'74be203d1cfe4b6094db2e05967c55ca', N'综合部（控申）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-06-10 10:03:11.103' AS DateTime), 57, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'76f4e4c0797d44afb8084ac8b22b19b2', N'武汉市公安局桥口区交通大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-29 11:53:37.830' AS DateTime), 48, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'7a21e6f3d9424332ae800285a044637a', N'绝密', N'', N'#C30052', 0, N'', N'密级', CAST(N'2016-05-18 10:33:11.000' AS DateTime), 1, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'7b5a0847283d475dae4892b22ca68e2a', N'公诉部（未成年人公诉案件）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 14:15:01.087' AS DateTime), 80, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'7d304ea28ddd4227aca18ceb33fbf754', N'金石', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:23:35.000' AS DateTime), 3, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'7dfbf9f72d854a15af263203271dc94e', N'财务报告', N'', N'', 0, N'', N'会计类别', CAST(N'2016-05-18 10:28:28.303' AS DateTime), 4, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'80dfeca822904c5ca6c7ddff98c0b145', N'硚口区公安分局法制大队（新安所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 15:46:38.170' AS DateTime), 32, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'82657a7b9c2947199e79d82b98c1a664', N'法制大队（宝丰）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-05-10 16:09:31.607' AS DateTime), 56, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'82cc43791a5f4f0f94e3c6185efd9624', N'新安所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-05-10 15:45:46.513' AS DateTime), 55, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'8309b6d673a2433b99393d383536fc4a', N'反渎职侵权局', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-23 09:37:30.690' AS DateTime), 40, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'833ba98cdca44a7d8e00799da3a5d8b9', N'会计账簿', N'', N'', 0, N'', N'会计类别', CAST(N'2016-05-18 10:27:55.890' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'8706b6de87014b838cd527de3a05a827', N'锦旗', N'', N'', 0, N'', N'实物类型', CAST(N'2016-05-18 10:25:36.650' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'8ffc198e30784e94960d3f6c6908940b', N'刑事诉讼案', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-07-01 09:11:37.573' AS DateTime), 59, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'90bdb17d49634b8989d6cd0f770dc4e0', N'新安派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-10 08:58:19.340' AS DateTime), 68, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'957f7c058e2f4d659f613b761ce045a8', N'秘密', N'', N'#FFB900', 0, N'', N'密级', CAST(N'2016-05-18 10:33:25.000' AS DateTime), 3, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'9580ac37c85a495c9f76da58b7a3bb4d', N'民事行政检察', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-06-11 11:32:13.863' AS DateTime), 58, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'97c5e0b5cc734e27b60f8c6bf4298905', N'硚口分局韩家所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-08-27 09:29:50.953' AS DateTime), 61, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'987db5f2fd6a485d8ecb6d00cc625643', N'荣华', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 16:23:45.700' AS DateTime), 33, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'9a0e022e84e242a6bc7ff7f46e62c515', N'审查批捕科', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-03-20 14:59:05.340' AS DateTime), 53, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'9a1924ed657548329eebc74d7dca0b8b', N'查阅信息', N'cyxx', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:03:24.963' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'9be205a69226481396489b2256d5ec8f', N'硚口区公安分局法制大队（荣华所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-27 14:05:44.010' AS DateTime), 71, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'9c12e2884f8d4f988823bd5173269ffe', N'法制大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-27 14:03:11.943' AS DateTime), 69, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'9e06ccffe4dd41bd952e2b47ea499969', N'公诉部', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-13 13:24:29.170' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'9e328f72d3c041558fd73f3dd3970038', N'公诉科', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-15 09:17:36.307' AS DateTime), 10, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'a0c5ffd407a94a8ca4be0233387ed6ef', N'胶片', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:21:48.000' AS DateTime), 7, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'a181507b2df444869187723841225e97', N'经侦大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-30 16:47:05.483' AS DateTime), 50, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'a1f912c9563345efbadb00f1a4048130', N'15年', N'15N', N'文书', 0, N'', N'保管期限', CAST(N'2016-02-02 10:46:29.000' AS DateTime), 25, NULL, NULL, N'15年', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                INSERT INTO TBaseData VALUES (N'a319d0d07db146cea044f857f4230f00', N'宝丰派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 10:38:17.000' AS DateTime), 24, NULL, NULL, N'', N'', N'', N'', N'0');
                //                INSERT INTO TBaseData VALUES (N'a3f6c276a7074f7c8d1c0ea39724bf5e', N'荣华派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-09 10:34:03.263' AS DateTime), 74, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'a4482a693eeb42de999c7f7f110fc718', N'硚口韩家所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-12-06 11:00:44.513' AS DateTime), 51, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'a4daf1807081420181af433a1aeb790c', N'法制大队（汉水）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-08-28 14:32:36.373' AS DateTime), 63, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'a53910b7da544c73955824a7160d9783', N'硚口区公安局法制大队', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-10 08:56:53.470' AS DateTime), 66, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //                INSERT INTO TBaseData VALUES (N'a551c7309c28445a91aa372f201d4ed0', N'盒', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:26:21.760' AS DateTime), 4, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //                ";

                //_ = baseDataServer.ExecSqlAsync(sql);

                //sql = @"INSERT INTO TBaseData VALUES (N'a905306b8d8d4306ac6180881becb831', N'唱片', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:21:38.000' AS DateTime), 6, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'aa08dc0b34814c32a9790bb74b06eeca', N'内部', N'', N'#00B7C3', 0, N'', N'密级', CAST(N'2016-05-18 10:33:47.000' AS DateTime), 5, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'ab8bb6b265cc4a1c9c1b467803380f6c', N'汉水桥街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 10:40:18.247' AS DateTime), 27, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'ae167f51bc9b46158eeb107d74feb513', N'30年', N'30N', N'文书', 0, N'', N'保管期限', CAST(N'2016-02-02 10:47:09.000' AS DateTime), 26, NULL, NULL, N'30年', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'ae26a3c7566841a784d39a160caa363e', N'案卷审判', N'ajsp', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:05:01.410' AS DateTime), 5, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'b0fc451b049643a889b0d6a9f877a756', N'简牍', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:21:06.000' AS DateTime), 4, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'b117c4bfca434dddb47a742ad881a265', N'法制大队（宗关）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 15:30:14.560' AS DateTime), 30, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'b51495156a53445e99abd0885a10c216', N'申诉复查', N'ssfc', N'', 0, N'', N'借卷目的', CAST(N'2016-02-02 11:05:22.883' AS DateTime), 6, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'b75cae429f4e4304ad8fcdae9865c887', N'法制大队（宝丰所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-09 10:35:14.307' AS DateTime), 75, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'b841c8dbca944d5bbdb985d9ebda39b8', N'磁带', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:22:14.000' AS DateTime), 9, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'bc0cde572f0a4c1483e2ece59a04067e', N'宝丰所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-09 10:36:21.730' AS DateTime), 76, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'bcfef22632a44058b24ab63c59c37f44', N'32开', N'', N'', 0, N'', N'规格', CAST(N'2016-05-18 10:27:06.123' AS DateTime), 1, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'bd9b9191c4344bbc9d4ee851e19ef55e', N'盘', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:26:46.193' AS DateTime), 7, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'c4b294cb28384449adf6f01402d13eb9', N'长丰派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 10:43:22.343' AS DateTime), 28, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'c5f370cfb7514b5facce0fdb182455ae', N'硚口区公安分局法制大队（六角）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-14 11:33:48.507' AS DateTime), 7, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'c7b4cc7a94ce452da779b740e60cbf37', N'会计凭证', N'', N'', 0, N'', N'会计类别', CAST(N'2016-05-18 10:28:06.470' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'c7b763f3d17540a1a8bc47dd99f14d8e', N'文检', N'05', N'', 0, N'', N'技术类别', CAST(N'2016-05-24 15:59:23.870' AS DateTime), 4, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'cb02b72d9c574b359833d0b13787647c', N'长期', N'2', N'诉讼', 0, N'', N'保管期限', CAST(N'2017-08-10 16:34:53.000' AS DateTime), 2, NULL, NULL, N'长期', N'', N'', N'', N'0');
                //        INSERT INTO TBaseData VALUES (N'cb4f0254364041c0a36f6cc3b62c7097', N'米', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:26:38.760' AS DateTime), 6, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'ce193a1a4ddc4db8b708029c58ba48a2', N'硚口区公安分局法制大队（韩家所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-15 17:29:30.323' AS DateTime), 15, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'ceb2209f10174d379b5b4babb33a0cfd', N'反贪局', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-19 16:35:25.800' AS DateTime), 21, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'd72ec3eb6c2b4420a089c82b9af19772', N'司法会计', N'03', N'', 0, N'', N'技术类别', CAST(N'2016-05-24 15:58:55.503' AS DateTime), 2, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'd8aa5f1ed71e449abde0be80c86dd260', N'甲骨', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:23:17.000' AS DateTime), 2, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'd9a27ae6f3844997bfa932e9175d92e1', N'刑事侦查卷', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-04-16 09:02:57.937' AS DateTime), 54, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'dfac20ff695a462f81a212807ea0baa5', N'硚口区公安分局法制大队（汉中所）', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 11:04:29.210' AS DateTime), 29, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'dff1f0774d5f49b586a1b7602177fe70', N'法医', N'04', N'', 0, N'', N'技术类别', CAST(N'2016-05-24 15:59:09.453' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'e0923a9cd8ce4d478955392ca61f5af3', N'汉中派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-09 10:32:27.320' AS DateTime), 73, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'e99e21d69c3a4479b0e87f6da9d72911', N'汉正街新安派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 15:43:18.517' AS DateTime), 31, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'ea1ad36afe8f4b18a41b0d2a47b629b2', N'硚口区公安局法制大队（易家）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 11:02:18.193' AS DateTime), 78, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'ebec74846d5c447bb1a41e1470e29751', N'古田派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-20 10:38:40.860' AS DateTime), 25, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'ef05556eafb94a538580299243b7c5de', N'册', N'', N'', 0, N'', N'载体单位', CAST(N'2016-05-18 10:26:13.217' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'f046a3dc82574f99a4611c242dc012d5', N'8开', N'', N'', 0, N'', N'规格', CAST(N'2016-05-18 10:27:22.820' AS DateTime), 3, NULL, NULL, NULL, NULL, NULL, N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'f221cf799313421cbbc8a67f4d761dd8', N'胶卷', N'', N'', 0, N'', N'载体类型', CAST(N'2016-05-18 10:22:02.000' AS DateTime), 8, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'f3e202b7168e46c18d7f0042ce751b9e', N'硚口公安分局荣华街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-15 17:05:00.663' AS DateTime), 13, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'f40ca38779a841fbb7bda1a1062b76ff', N'硚口区公安分局法制大队（长丰）', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-10-17 14:57:16.023' AS DateTime), 82, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'f8b5372a765646e5a45cef039ce42756', N'利济', N'', N'', 0, N'', N'立卷单位', CAST(N'2018-11-14 11:16:07.427' AS DateTime), 5, NULL, NULL, NULL, NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'f8dd7b0e79564b678cb8465aef39fa5a', N'短期', N'D', N'文书', 0, N'', N'保管期限', CAST(N'2016-02-02 10:46:10.000' AS DateTime), 23, NULL, NULL, N'短期', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        INSERT INTO TBaseData VALUES (N'f9629f63c47c44858bbb7dc25d70c436', N'短期', N'3', N'诉讼', 0, N'', N'保管期限', CAST(N'2017-08-10 16:35:02.000' AS DateTime), 3, NULL, NULL, N'短期', N'', N'', N'', N'0');
                //        INSERT INTO TBaseData VALUES (N'f9c8705d75cc4407bba91f8e787f59fe', N'利济派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-08-29 09:03:55.753' AS DateTime), 64, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'fab2311bea3440afb96e688bfc13fc93', N'古田街派出所', N'', N'', 0, N'', N'立卷单位', CAST(N'2019-09-27 14:06:31.550' AS DateTime), 72, NULL, NULL, N'', NULL, NULL, NULL, N'0');
                //        INSERT INTO TBaseData VALUES (N'fbb29b0a18784423b4d59833e7fc2a3d', N'机密', N'', N'#F7630C', 0, N'', N'密级', CAST(N'2016-05-18 10:33:18.000' AS DateTime), 2, NULL, NULL, N'', N'', N'', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0');
                //        ";
                //_ = baseDataServer.ExecSqlAsync(sql);
            }

            if (_tmenuServer.Count() == 0)
            {
                //string sql = @" INSERT INTO TMenu VALUES ('12e11f3e283e4fb396304359550b7ad5', 'OA办公归档', '/filesBefore/index.aspx', 'fa fa-file-word-o', NULL, 2, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '管理', NULL, NULL, '0', NULL);
                //                INSERT INTO TMenu VALUES('19e4e2192d5647d79a4201580bc90518', '科技档案', '/scan3/index.aspx', 'fa fa-laptop', NULL, 110, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('23fdff0f25d344ec9b7d9ef0964f6570', '菜单权限', '/Menu/MenuManager.aspx', 'fa fa-heart', NULL, 998, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '系统', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('25a54562be224c8c96b4edffd085c24f', '我的诉讼档案', '/scan9/SuSong.aspx', 'fa fa-gavel', NULL, 21, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,2cb2a63658894adab036e39893a4fe1e,80dbc285276145699bc0eb56fb47bd5c,dc29983d95664cc89eb6b8001a379e04,19f28ad4670048008ece2b899ba2880c,C729CB982DB04F1681D705B0711692C6,B406ED842B89485C85841951636643F5,6A3DC5971BF54059B9EF7F0797C909C5,7B5D4766EE974C6E91253010EF9A1068,F57745AEDA8749D8AE422AC186D0CDFC,F3AF9F845334454EBC38683BAFE67145,8389BC9F787149CF8F17FF98E9EDEFD4,2B0CF0A4AFE449629529B0913BCE5695,3AC254377BC446C1A004D087B79C0243,A74C4F96412C4A2C8E5AE2BEF8567A0A', '个人', NULL, NULL, '0', NULL);
                //                INSERT INTO TMenu VALUES('27f31195cd0d4e339a514443e32c99f0', '会计档案', '/scan7/Accounting.aspx', 'fa fa-money', NULL, 114, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('2a16ca7994f3491c8b809311dd6c1c4a', '数据备份', 'javascript:;', 'fa fa-tv', NULL, 1000, NULL, NULL, '2113885a1d63483da41080942686a84b', '系统', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('30da458e1b854a4c87f1384f677df34e', '文书档案', '/Instruments.aspx', 'fa fa-book', NULL, 10, NULL, NULL, '2113885a1d63483da41080942686a84b,2cb2a63658894adab036e39893a4fe1e,80dbc285276145699bc0eb56fb47bd5c,dc29983d95664cc89eb6b8001a379e04,19f28ad4670048008ece2b899ba2880c,6A3DC5971BF54059B9EF7F0797C909C5,2B0CF0A4AFE449629529B0913BCE5695', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('32461da0518546a58d46253f5c19cb40', '声像档案', '/scan4/index.aspx', 'fa fa-video-camera', NULL, 111, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('43ba6c8cdcb74567a9a501b6ee5dc179', '基础数据', '/BaseData.aspx', 'fa fa-cube', NULL, 154, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('4bd31eee762849eeb849f8800e270f6f', '信息统计', '/FilesStatistics/Statistics.aspx', 'fa fa-bar-chart', NULL, 140, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('586e847b60dd49ed9ad4aa1723b095d4', '实物档案', '/scan8/Real.aspx', 'fa fa-trophy', NULL, 115, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('63e91d11dd264b6d8dd143b339c03931', '档案移交接收', '/FilesReceive/index.aspx', 'fa fa-retweet', NULL, 130, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('6742c0394eae4cf5a1b60fc6d19f3a93', '电子档案', '/scan5/index.aspx', 'fa fa-bolt', NULL, 112, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('6c4634792c574ee68f58070501a0a74b', '问题分类', '/Problem/index.aspx', 'fa fa-leaf', NULL, 153, NULL, NULL, '2113885a1d63483da41080942686a84b', '管理', '', '', '0', NULL);
                //                INSERT INTO TMenu VALUES('6ec8baf5ced0450d9734774e4496822a', '档案审核', '/FilesSH/index.aspx', 'fa fa-star', NULL, 156, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c,6A3DC5971BF54059B9EF7F0797C909C5,2B0CF0A4AFE449629529B0913BCE5695', '管理', NULL, NULL, '0', NULL);
                //                INSERT INTO TMenu VALUES('72c2536d0c6d453ca292814a3846161f', '诉讼档案加工', '/scan1/index.aspx', 'fa fa-briefcase', NULL, 121, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '加工', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('76c1128d34e94f7eb101e7544b0c389e', '系统设置', '/Setting.aspx', 'fa fa-wrench', NULL, 999, NULL, NULL, '2113885a1d63483da41080942686a84b', '系统', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('7999a6a6c80e4be583e7462ea6df9fd1', '文书档案加工', '/scan2/index.aspx', 'fa fa-file-image-o', NULL, 120, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '加工', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('847ea9bebc234932911b3bac755e6c57', '智能搜索', '/Search.aspx', 'fa fa-paw', NULL, 0, NULL, NULL, '', '个人', '', '', '0', NULL);
                //                INSERT INTO TMenu VALUES('8a5fb735514d4674ae861d403c5e26ed', '用户管理', '/User/UserManager.aspx', 'fa fa-user', NULL, 152, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('924f024eee1f4a728665cc6737858e68', '系统日志', '/Log.aspx', 'fa fa-sticky-note', NULL, 997, NULL, NULL, '2113885a1d63483da41080942686a84b', '系统', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('9580b60b3ed44a0089ab6bf84782708e', '卷皮打印设置', '/PrintSetting/PrintSetting.aspx', 'fa fa-print', NULL, 900, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '加工', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('9d682cdeeef642ca8ffefafb9553dcc3', '文本对比', '/diff.html', 'fa fa-bookmark-o', NULL, 1, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '系统', NULL, '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('b00144ea612e4a14ace18e8a7a7af530', '业务系统归档', '/FilesArchive/index.aspx', 'fa fa-archive', NULL, 1, NULL, NULL, '', '管理', NULL, '27137dffa6bb48bc9b7f97dc82964dd4', '1', NULL);
                //                INSERT INTO TMenu VALUES('b038379420ac49cf8418723a0ff3fab8', '诉讼档案', '/Litigation.aspx', 'fa fa-balance-scale', NULL, 20, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,2cb2a63658894adab036e39893a4fe1e,80dbc285276145699bc0eb56fb47bd5c,dc29983d95664cc89eb6b8001a379e04', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('b3ee338e57264e0f88813b99bfeeed2b', '我的文书档案', '/scan9/WenShu.aspx', 'fa fa-file-word-o', NULL, 11, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '个人', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('bd5fd79fe43748339cc30acdf7b14968', '我的申请', '/FilesApply/MyApplyList.aspx', 'fa fa-leaf', NULL, 160, NULL, NULL, '2113885a1d63483da41080942686a84b,ecb6787849594677bdfd19e8a4dbad73,07b47bde095147109043859e5ab293ff,1c1f17657b9c47b397b8b8c21eaddf4a,c4a765b523b44c8aaac14942a2640ce5,aa932ddcbd37436693e8993505bc3107,41d88f0e1ff34d75bafc65e276fd62c6,4fd9f33602b44a0a9809906434883fd8,549dd758b4ea4464b1c29695b35f692d,8bf298f936e248fca830022985e2465c,d4907605837d45e4b25d5b696940ff89,2cb2a63658894adab036e39893a4fe1e,80dbc285276145699bc0eb56fb47bd5c,dc29983d95664cc89eb6b8001a379e04,19f28ad4670048008ece2b899ba2880c', '个人', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('ddc9bbb967564312b023c4626a4a2cde', '阅卷授权', '/FilesAuthority/index.aspx', 'fa fa-newspaper-o', NULL, 155, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('e1b77647449347faa8717a88b0e656fc', '技术档案', '/scan6/Technology.aspx', 'fa fa-ticket', NULL, 113, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89', '档案', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('e51bac4ae8d746c4a67c60e7a6e9e8a4', '报表打印', '/Transfer/index.aspx', 'fa fa-print', NULL, 124, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c,C729CB982DB04F1681D705B0711692C6,6A3DC5971BF54059B9EF7F0797C909C5,F3AF9F845334454EBC38683BAFE67145,2B0CF0A4AFE449629529B0913BCE5695', '加工', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('e550550c75584a0c806b3a53dd87d8e0', '业务系统归档', '/FilesArchive/index.aspx', 'fa fa-file-word-o', NULL, 1, NULL, NULL, '2113885a1d63483da41080942686a84b,80dbc285276145699bc0eb56fb47bd5c', '管理', '', '', '0', NULL);
                //                INSERT INTO TMenu VALUES('e65eb545fb314284bc6716a9639e8dee', '人员身份', '/Role/UserRole.aspx', 'fa fa-paw', NULL, 151, NULL, NULL, '2113885a1d63483da41080942686a84b', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('ee1f5c8f4d2a4f95ac71cd4fbec034f5', '数据挂接', '/DataImport/index.aspx', 'fa fa-database', NULL, 996, NULL, NULL, '2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,80dbc285276145699bc0eb56fb47bd5c', '系统', '', '', '0', NULL);
                //                INSERT INTO TMenu VALUES('f312e94fe12f4fb6927505136d8214d3', '组织机构', '/Department/index.aspx', 'fa fa-group', NULL, 150, NULL, NULL, '2113885a1d63483da41080942686a84b', '管理', '', '27137dffa6bb48bc9b7f97dc82964dd4', '0', NULL);
                //                INSERT INTO TMenu VALUES('f69ddc895a494fb28fb4a5e9eac229a3', '重复数据清除', '/update/ClearInput.aspx', 'fa fa-recycle', NULL, 1001, NULL, NULL, '2113885a1d63483da41080942686a84b', '系统', NULL, NULL, '0', NULL);";

                //_ = _tmenuServer.ExecSqlAsync(sql);


                TMenu menu = new TMenu();
                menu.ID = "19e4e2192d5647d79a4201580bc90518";
                menu.MenuName = "科技档案";
                menu.PageUrl = "/scan3/index.aspx";
                menu.ImgPath = "fa fa-file-word-o";
                menu.Flag1 = 110;
                menu.Bak1 = "2113885a1d63483da41080942686a84b,d4907605837d45e4b25d5b696940ff89,87f7fcaf05464ffb93556e902a4ad7c5";
                menu.Bak2 = "档案";
                menu.DMID = "27137dffa6bb48bc9b7f97dc82964dd4";
                menu.IsDelete = "0";

                _tmenuServer.Insert(menu);
            }

            if (_menuServer.Count() == 0)
            {
                //string sql = @" INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32e5', N'诉讼档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/Litigation.aspx', N'fa fa-file-archive-o fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'17ddc5ac95b54dfd96ca89813fdd7ce5', N'传统文书', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/InsSearch1.aspx', N'fa fa-book fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'af4ccc77935b4649988a06a36873a039', N'简化文书', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/InsSearch2.aspx', N'fa fa-book fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'2deb75ea2b8341efa3b74f25fc736fh1', N'科技档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan3/KeJi.aspx', N'fa fa-university fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'2deb75ea2b8341efa3b74f25fc736ff1', N'声像档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan4/YinXiang.aspx', N'fa fa-file-movie-o fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'2deb75ea2b8341efa3b74f25fc736fl1', N'电子档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan5/DianZi.aspx', N'fa fa-file-excel-o fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'98bdc691952f41c19be62d84fae95d69', N'技术档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan6/JiShu.aspx', N'fa fa-magnet fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'3a9edc68c84a4f54890158163d65228f', N'会计档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan7/KuaiJi.aspx', N'fa fa-money fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'2deb75ea2b8341efa3b74f25fc736fe1', N'实物档案', N'0', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan8/ShiWu.aspx', N'fa fa-trophy fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'7171ffa5452d49a9b940066bf4d57fb9', N'基建档案', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan3/CapitalCon.aspx', N'fa fa-university fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'68a47eb026da4d2aa46889ff1362502e', N'工程项目', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan3/EngDevice.aspx', N'fa fa-cubes fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'4f33cc7da73a4136a5384870db46612c', N'设备档案', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/Equipment/TEquipment.aspx', N'fa fa-building fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'2a2538ead3ad49e3911552238905527c', N'视频、录像', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan11/AudioVideo.aspx', N'fa fa-video-camera fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'274f9f37714f498e97f0f47286df9834', N'照片档案', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan4/Image.aspx', N'fa fa-photo fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'b1bb9499564a437ab05ac1693d85465d', N'光盘', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan5/Electronic.aspx', N'fa fa-desktop fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'94c7d105d21f4507b023d7593a380e5e', N'电子文件', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan5/EleFile.aspx', N'fa fa-plug fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32a5', N'音频、录音', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan4/Sound.aspx', N'fa fa-volume-up fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32d5', N'移动硬盘', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan5/Electronic.aspx?type=%27移动硬盘%27', N'fa fa-hdd-o fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32h5', N'痕检', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan6/Technology.aspx?type=%27痕检%27', N'fa fa-share-alt-square fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32j5', N'文检', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan6/Technology.aspx?type=%27文检%27', N'fa fa-pencil-square fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32k5', N'法医', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan6/Technology.aspx?type=%27法医%27', N'fa fa-hotel fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32l5', N'司法会计', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan6/Technology.aspx?type=%27司法会计%27', N'fa fa-creative-commons fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32x5', N'电子证据检验', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan6/Technology.aspx?type=%27电子证据检验%27', N'fa fa-exclamation-circle fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32v5', N'会计账簿', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan7/Accounting.aspx?KJType=%27会计账簿%27', N'fa fa-cc fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32m5', N'会计凭证', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan7/Accounting.aspx?KJType=%27会计凭证%27', N'fa fa-money fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32p5', N'会计报表', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan7/Accounting.aspx?KJType=%27会计报表%27', N'fa fa-bar-chart fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32r5', N'奖品', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan8/Real.aspx?RealType=%27奖品%27', N'fa fa-trophy fa-5x');
                //                INSERT INTO HomeMenu VALUES (N'e44db7491456436cb160cd4f1cff32s5', N'印章', N'1', N'27137dffa6bb48bc9b7f97dc82964dd4', N'0', N'/scan8/Real.aspx?RealType=%27印章%27', N'fa fa-bullseye fa-5x');
                //                ";
                //_ = _menuServer.ExecSqlAsync(sql);
            }
        }
    }
}
